Pandas Profiling Report

Dataset statistics

Number of variables	14
Number of observations	1404
Missing cells	2691
Missing cells (%)	13.7%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	153.7 KiB
Average record size in memory	112.1 B

Variable types

Numeric	11
Categorical	3

Alerts

`Geo_Desc` has a high cardinality: 52 distinct values	High cardinality
`Year` is highly overall correlated with `Opioid_Prscrbng_Rate`	High correlation
`Geo_Cd` is highly overall correlated with `Geo_Lvl` and 1 other fields	High correlation
`Tot_Opioid_Clms` is highly overall correlated with `Tot_Clms` and 2 other fields	High correlation
`Tot_Clms` is highly overall correlated with `Tot_Opioid_Clms` and 2 other fields	High correlation
`Opioid_Prscrbng_Rate` is highly overall correlated with `Year`	High correlation
`LA_Tot_Opioid_Clms` is highly overall correlated with `Tot_Opioid_Clms` and 2 other fields	High correlation
`LA_Opioid_Prscrbng_Rate` is highly overall correlated with `LA_Opioid_Prscrbng_Rate_5Y_Chg`	High correlation
`LA_Opioid_Prscrbng_Rate_5Y_Chg` is highly overall correlated with `LA_Opioid_Prscrbng_Rate`	High correlation
`Geo_Lvl` is highly overall correlated with `Geo_Cd` and 4 other fields	High correlation
`Geo_Desc` is highly overall correlated with `Geo_Cd` and 1 other fields	High correlation
`Geo_Lvl` is highly imbalanced (86.3%)	Imbalance
`Geo_Cd` has 27 (1.9%) missing values	Missing
`Tot_Opioid_Clms` has 18 (1.3%) missing values	Missing
`Opioid_Prscrbng_Rate` has 132 (9.4%) missing values	Missing
`Opioid_Prscrbng_Rate_5Y_Chg` has 852 (60.7%) missing values	Missing
`Opioid_Prscrbng_Rate_1Y_Chg` has 285 (20.3%) missing values	Missing
`LA_Tot_Opioid_Clms` has 36 (2.6%) missing values	Missing
`LA_Opioid_Prscrbng_Rate` has 156 (11.1%) missing values	Missing
`LA_Opioid_Prscrbng_Rate_5Y_Chg` has 872 (62.1%) missing values	Missing
`LA_Opioid_Prscrbng_Rate_1Y_Chg` has 311 (22.2%) missing values	Missing
`Geo_Desc` is uniformly distributed	Uniform
`Plan_Type` is uniformly distributed	Uniform
`Tot_Opioid_Clms` has 120 (8.5%) zeros	Zeros
`Tot_Clms` has 114 (8.1%) zeros	Zeros
`LA_Tot_Opioid_Clms` has 130 (9.3%) zeros	Zeros

Reproduction

Analysis started	2023-09-19 14:02:59.558407
Analysis finished	2023-09-19 14:03:42.566292
Duration	43.01 seconds
Software version	pandas-profiling v3.6.6
Download configuration	config.json

Year
Real number (ℝ)

Distinct	9
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2017

Minimum	2013
Maximum	2021
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	11.1 KiB

Quantile statistics

Minimum	2013
5-th percentile	2013
Q1	2015
median	2017
Q3	2019
95-th percentile	2021
Maximum	2021
Range	8
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.5829089
Coefficient of variation (CV)	0.0012805696
Kurtosis	-1.2301059
Mean	2017
Median Absolute Deviation (MAD)	2
Skewness	0
Sum	2831868
Variance	6.6714184
Monotonicity	Decreasing

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
2021	156	11.1%
2020	156	11.1%
2019	156	11.1%
2018	156	11.1%
2017	156	11.1%
2016	156	11.1%
2015	156	11.1%
2014	156	11.1%
2013	156	11.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2013	156	11.1%
2014	156	11.1%
2015	156	11.1%
2016	156	11.1%
2017	156	11.1%
2018	156	11.1%
2019	156	11.1%
2020	156	11.1%
2021	156	11.1%

Value	Count	Frequency (%)
2021	156	11.1%
2020	156	11.1%
2019	156	11.1%
2018	156	11.1%
2017	156	11.1%
2016	156	11.1%
2015	156	11.1%
2014	156	11.1%
2013	156	11.1%

Geo_Lvl
Categorical

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	11.1 KiB

State	1377
National	27

Length

Max length	8
Median length	5
Mean length	5.0576923
Min length	5

Characters and Unicode

Total characters	7101
Distinct characters	9
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	National
2nd row	National
3rd row	National
4th row	State
5th row	State

Common Values

Value	Count	Frequency (%)
State	1377	98.1%
National	27	1.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
state	1377	98.1%
national	27	1.9%

Most occurring characters

Value	Count	Frequency (%)
t	2781	39.2%
a	1431	20.2%
S	1377	19.4%
e	1377	19.4%
N	27	0.4%
i	27	0.4%
o	27	0.4%
n	27	0.4%
l	27	0.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	5697	80.2%
Uppercase Letter	1404	19.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	2781	48.8%
a	1431	25.1%
e	1377	24.2%
i	27	0.5%
o	27	0.5%
n	27	0.5%
l	27	0.5%

Uppercase Letter

Value	Count	Frequency (%)
S	1377	98.1%
N	27	1.9%

Most occurring scripts

Value	Count	Frequency (%)
Latin	7101	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	2781	39.2%
a	1431	20.2%
S	1377	19.4%
e	1377	19.4%
N	27	0.4%
i	27	0.4%
o	27	0.4%
n	27	0.4%
l	27	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	7101	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
t	2781	39.2%
a	1431	20.2%
S	1377	19.4%
e	1377	19.4%
N	27	0.4%
i	27	0.4%
o	27	0.4%
n	27	0.4%
l	27	0.4%

Geo_Cd
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	51
Distinct (%)	3.7%
Missing	27
Missing (%)	1.9%
Infinite	0
Infinite (%)	0.0%
Mean	28.960784

Minimum	1
Maximum	56
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	11.1 KiB

Quantile statistics

Minimum	1
5-th percentile	4
Q1	16
median	29
Q3	42
95-th percentile	54
Maximum	56
Range	55
Interquartile range (IQR)	26

Descriptive statistics

Standard deviation	15.682531
Coefficient of variation (CV)	0.54150919
Kurtosis	-1.1044434
Mean	28.960784
Median Absolute Deviation (MAD)	13
Skewness	-0.01930637
Sum	39879
Variance	245.94177
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	27	1.9%
31	27	1.9%
32	27	1.9%
33	27	1.9%
34	27	1.9%
35	27	1.9%
36	27	1.9%
37	27	1.9%
38	27	1.9%
39	27	1.9%
Other values (41)	1107	78.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	27	1.9%
2	27	1.9%
4	27	1.9%
5	27	1.9%
6	27	1.9%
8	27	1.9%
9	27	1.9%
10	27	1.9%
11	27	1.9%
12	27	1.9%

Value	Count	Frequency (%)
56	27	1.9%
55	27	1.9%
54	27	1.9%
53	27	1.9%
51	27	1.9%
50	27	1.9%
49	27	1.9%
48	27	1.9%
47	27	1.9%
46	27	1.9%

Geo_Desc
Categorical

HIGH CARDINALITY HIGH CORRELATION UNIFORM

Distinct	52
Distinct (%)	3.7%
Missing	0
Missing (%)	0.0%
Memory size	11.1 KiB

National	27
Alabama	27
Nebraska	27
Nevada	27
New Hampshire	27
Other values (47)	1269

Length

Max length	20
Median length	12.5
Mean length	8.6538462
Min length	4

Characters and Unicode

Total characters	12150
Distinct characters	46
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	National
2nd row	National
3rd row	National
4th row	Alabama
5th row	Alabama

Common Values

Value	Count	Frequency (%)
National	27	1.9%
Alabama	27	1.9%
Nebraska	27	1.9%
Nevada	27	1.9%
New Hampshire	27	1.9%
New Jersey	27	1.9%
New Mexico	27	1.9%
New York	27	1.9%
North Carolina	27	1.9%
North Dakota	27	1.9%
Other values (42)	1134	80.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
new	108	6.2%
carolina	54	3.1%
virginia	54	3.1%
dakota	54	3.1%
south	54	3.1%
north	54	3.1%
national	27	1.6%
florida	27	1.6%
columbia	27	1.6%
of	27	1.6%
Other values (46)	1242	71.9%

Most occurring characters

Value	Count	Frequency (%)
a	1620	13.3%
i	1161	9.6%
o	972	8.0%
n	972	8.0%
s	837	6.9%
e	756	6.2%
r	594	4.9%
t	540	4.4%
l	432	3.6%
h	351	2.9%
Other values (36)	3915	32.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	10125	83.3%
Uppercase Letter	1701	14.0%
Space Separator	324	2.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	1620	16.0%
i	1161	11.5%
o	972	9.6%
n	972	9.6%
s	837	8.3%
e	756	7.5%
r	594	5.9%
t	540	5.3%
l	432	4.3%
h	351	3.5%
Other values (14)	1890	18.7%

Uppercase Letter

Value	Count	Frequency (%)
N	243	14.3%
M	243	14.3%
C	162	9.5%
I	135	7.9%
W	108	6.3%
A	108	6.3%
D	108	6.3%
V	81	4.8%
O	81	4.8%
K	54	3.2%
Other values (11)	378	22.2%

Space Separator

Value	Count	Frequency (%)
	324	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	11826	97.3%
Common	324	2.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	1620	13.7%
i	1161	9.8%
o	972	8.2%
n	972	8.2%
s	837	7.1%
e	756	6.4%
r	594	5.0%
t	540	4.6%
l	432	3.7%
h	351	3.0%
Other values (35)	3591	30.4%

Common

Value	Count	Frequency (%)
	324	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	12150	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	1620	13.3%
i	1161	9.6%
o	972	8.0%
n	972	8.0%
s	837	6.9%
e	756	6.2%
r	594	4.9%
t	540	4.4%
l	432	3.6%
h	351	2.9%
Other values (36)	3915	32.2%

Plan_Type
Categorical

Distinct	3
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	11.1 KiB

All	468
FFS	468
MC	468

Length

Max length	3
Median length	3
Mean length	2.6666667
Min length	2

Characters and Unicode

Total characters	3744
Distinct characters	6
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	All
2nd row	FFS
3rd row	MC
4th row	All
5th row	FFS

Common Values

Value	Count	Frequency (%)
All	468	33.3%
FFS	468	33.3%
MC	468	33.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
all	468	33.3%
ffs	468	33.3%
mc	468	33.3%

Most occurring characters

Value	Count	Frequency (%)
l	936	25.0%
F	936	25.0%
A	468	12.5%
S	468	12.5%
M	468	12.5%
C	468	12.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	2808	75.0%
Lowercase Letter	936	25.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
F	936	33.3%
A	468	16.7%
S	468	16.7%
M	468	16.7%
C	468	16.7%

Lowercase Letter

Value	Count	Frequency (%)
l	936	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3744	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
l	936	25.0%
F	936	25.0%
A	468	12.5%
S	468	12.5%
M	468	12.5%
C	468	12.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3744	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
l	936	25.0%
F	936	25.0%
A	468	12.5%
S	468	12.5%
M	468	12.5%
C	468	12.5%

Tot_Opioid_Clms
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	1147
Distinct (%)	82.8%
Missing	18
Missing (%)	1.3%
Infinite	0
Infinite (%)	0.0%
Mean	770834.79

Minimum	0
Maximum	37964067
Zeros	120
Zeros (%)	8.5%
Negative	0
Negative (%)	0.0%
Memory size	11.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	41961.25
median	182083
Q3	570217.25
95-th percentile	1782211.2
Maximum	37964067
Range	37964067
Interquartile range (IQR)	528256

Descriptive statistics

Standard deviation	3049433.7
Coefficient of variation (CV)	3.9560147
Kurtosis	81.357535
Mean	770834.79
Median Absolute Deviation (MAD)	178277.5
Skewness	8.5753739
Sum	1.068377 × 10⁹
Variance	9.2990461 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	120	8.5%
447039	2	0.1%
613637	2	0.1%
1017833	2	0.1%
49072	2	0.1%
645729	2	0.1%
150780	2	0.1%
132076	2	0.1%
507923	2	0.1%
1192423	2	0.1%
Other values (1137)	1248	88.9%
(Missing)	18	1.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	120	8.5%
12	1	0.1%
13	1	0.1%
24	1	0.1%
32	1	0.1%
47	1	0.1%
50	1	0.1%
62	1	0.1%
130	1	0.1%
161	1	0.1%

Value	Count	Frequency (%)
37964067	1	0.1%
37014898	1	0.1%
36902273	1	0.1%
33471552	1	0.1%
32240821	1	0.1%
25910488	1	0.1%
25287108	1	0.1%
24960573	1	0.1%
23122001	1	0.1%
22058928	1	0.1%

Tot_Clms
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	1175
Distinct (%)	83.8%
Missing	2
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	16592302

Minimum	0
Maximum	7.0429677 × 10⁸
Zeros	114
Zeros (%)	8.1%
Negative	0
Negative (%)	0.0%
Memory size	11.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1096489.2
median	4402720
Q3	11378235
95-th percentile	38677654
Maximum	7.0429677 × 10⁸
Range	7.0429677 × 10⁸
Interquartile range (IQR)	10281746

Descriptive statistics

Standard deviation	64943294
Coefficient of variation (CV)	3.9140618
Kurtosis	71.562763
Mean	16592302
Median Absolute Deviation (MAD)	3989145.5
Skewness	8.173525
Sum	2.3262407 × 10¹⁰
Variance	4.2176314 × 10¹⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	114	8.1%
529696	2	0.1%
4700499	2	0.1%
10569244	2	0.1%
7143629	2	0.1%
8285804	2	0.1%
442330	2	0.1%
7319465	2	0.1%
1396466	2	0.1%
7584452	2	0.1%
Other values (1165)	1270	90.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	114	8.1%
576	1	0.1%
2147	1	0.1%
3884	1	0.1%
4542	1	0.1%
4891	1	0.1%
5905	1	0.1%
6114	1	0.1%
7857	1	0.1%
8746	1	0.1%

Value	Count	Frequency (%)
704296772	1	0.1%
686625295	1	0.1%
685892618	1	0.1%
685821751	1	0.1%
679767097	1	0.1%
653713145	1	0.1%
641988059	1	0.1%
571877738	1	0.1%
508189967	1	0.1%
506882862	1	0.1%

Opioid_Prscrbng_Rate
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	664
Distinct (%)	52.2%
Missing	132
Missing (%)	9.4%
Infinite	0
Infinite (%)	0.0%
Mean	5.0143396

Minimum	0
Maximum	29.44
Zeros	6
Zeros (%)	0.4%
Negative	0
Negative (%)	0.0%
Memory size	11.1 KiB

Quantile statistics

Minimum	0
5-th percentile	1.4955
Q1	3.09
median	4.64
Q3	6.42
95-th percentile	9.5925
Maximum	29.44
Range	29.44
Interquartile range (IQR)	3.33

Descriptive statistics

Standard deviation	2.783966
Coefficient of variation (CV)	0.55520093
Kurtosis	8.7015997
Mean	5.0143396
Median Absolute Deviation (MAD)	1.69
Skewness	1.8186794
Sum	6378.24
Variance	7.7504669
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2.87	7	0.5%
4.18	7	0.5%
5.55	7	0.5%
0	6	0.4%
3.18	6	0.4%
4.4	6	0.4%
5.76	6	0.4%
2.95	6	0.4%
2.75	6	0.4%
4.88	6	0.4%
Other values (654)	1209	86.1%
(Missing)	132	9.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	6	0.4%
0.02	1	0.1%
0.03	1	0.1%
0.04	1	0.1%
0.05	1	0.1%
0.15	1	0.1%
0.23	1	0.1%
0.29	1	0.1%
0.35	1	0.1%
0.38	1	0.1%

Value	Count	Frequency (%)
29.44	1	0.1%
24.2	1	0.1%
20.1	1	0.1%
19.68	1	0.1%
18.49	1	0.1%
18.36	1	0.1%
17.78	1	0.1%
16.19	1	0.1%
16	1	0.1%
15.36	1	0.1%

Opioid_Prscrbng_Rate_5Y_Chg
Real number (ℝ)

Distinct	330
Distinct (%)	59.8%
Missing	852
Missing (%)	60.7%
Infinite	0
Infinite (%)	0.0%
Mean	-2.8291486

Minimum	-10.42
Maximum	16.19
Zeros	0
Zeros (%)	0.0%
Negative	520
Negative (%)	37.0%
Memory size	11.1 KiB

Quantile statistics

Minimum	-10.42
5-th percentile	-5.716
Q1	-3.91
median	-3.065
Q3	-2.2375
95-th percentile	0.8525
Maximum	16.19
Range	26.61
Interquartile range (IQR)	1.6725

Descriptive statistics

Standard deviation	2.4213161
Coefficient of variation (CV)	-0.85584624
Kurtosis	15.870123
Mean	-2.8291486
Median Absolute Deviation (MAD)	0.845
Skewness	2.7550462
Sum	-1561.69
Variance	5.8627719
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-2.92	7	0.5%
-3.33	6	0.4%
-3.37	6	0.4%
-3.76	5	0.4%
-2.88	5	0.4%
-2.33	5	0.4%
-2.15	5	0.4%
-2.44	5	0.4%
-3.07	5	0.4%
-1.13	5	0.4%
Other values (320)	498	35.5%
(Missing)	852	60.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-10.42	1	0.1%
-9.91	1	0.1%
-9.48	1	0.1%
-9.21	1	0.1%
-8.67	1	0.1%
-7.64	1	0.1%
-7.46	1	0.1%
-7.32	1	0.1%
-7	1	0.1%
-6.83	1	0.1%

Value	Count	Frequency (%)
16.19	1	0.1%
13.84	1	0.1%
10.86	1	0.1%
8.99	1	0.1%
8.9	1	0.1%
7.12	1	0.1%
6.65	1	0.1%
6.45	1	0.1%
5.93	1	0.1%
5.7	1	0.1%

Opioid_Prscrbng_Rate_1Y_Chg
Real number (ℝ)

Distinct	258
Distinct (%)	23.1%
Missing	285
Missing (%)	20.3%
Infinite	0
Infinite (%)	0.0%
Mean	-0.44741734

Minimum	-4.1
Maximum	15.31
Zeros	4
Zeros (%)	0.3%
Negative	982
Negative (%)	69.9%
Memory size	11.1 KiB

Quantile statistics

Minimum	-4.1
5-th percentile	-1.431
Q1	-0.82
median	-0.48
Q3	-0.18
95-th percentile	0.351
Maximum	15.31
Range	19.41
Interquartile range (IQR)	0.64

Descriptive statistics

Standard deviation	1.0387954
Coefficient of variation (CV)	-2.3217594
Kurtosis	86.899307
Mean	-0.44741734
Median Absolute Deviation (MAD)	0.31
Skewness	6.9363108
Sum	-500.66
Variance	1.0790959
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-0.39	18	1.3%
-0.67	16	1.1%
-0.17	16	1.1%
-0.51	15	1.1%
-0.56	15	1.1%
-0.28	14	1.0%
-0.48	14	1.0%
-0.18	14	1.0%
-0.26	13	0.9%
-0.13	13	0.9%
Other values (248)	971	69.2%
(Missing)	285	20.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-4.1	1	0.1%
-3.5	1	0.1%
-3.49	1	0.1%
-3.47	1	0.1%
-3.4	1	0.1%
-3.18	1	0.1%
-2.93	1	0.1%
-2.86	1	0.1%
-2.84	1	0.1%
-2.77	1	0.1%

Value	Count	Frequency (%)
15.31	1	0.1%
13.25	1	0.1%
9.06	1	0.1%
7.02	1	0.1%
7	1	0.1%
6.36	1	0.1%
4.26	1	0.1%
4.01	1	0.1%
3.79	1	0.1%
2.78	2	0.1%

LA_Tot_Opioid_Clms
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	1094
Distinct (%)	80.0%
Missing	36
Missing (%)	2.6%
Infinite	0
Infinite (%)	0.0%
Mean	80656.536

Minimum	0
Maximum	4672903
Zeros	130
Zeros (%)	9.3%
Negative	0
Negative (%)	0.0%
Memory size	11.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	3646
median	14459
Q3	46538
95-th percentile	150874.65
Maximum	4672903
Range	4672903
Interquartile range (IQR)	42892

Descriptive statistics

Standard deviation	347495.96
Coefficient of variation (CV)	4.3083422
Kurtosis	73.86094
Mean	80656.536
Median Absolute Deviation (MAD)	13613
Skewness	8.0951964
Sum	1.1033814 × 10⁸
Variance	1.2075344 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	130	9.3%
12207	3	0.2%
4230	2	0.1%
30850	2	0.1%
8657	2	0.1%
22998	2	0.1%
15295	2	0.1%
65204	2	0.1%
53120	2	0.1%
10307	2	0.1%
Other values (1084)	1219	86.8%
(Missing)	36	2.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	130	9.3%
11	1	0.1%
16	2	0.1%
22	1	0.1%
23	1	0.1%
31	1	0.1%
37	2	0.1%
45	1	0.1%
49	2	0.1%
50	1	0.1%

Value	Count	Frequency (%)
4672903	1	0.1%
4008483	1	0.1%
3936336	1	0.1%
3296403	1	0.1%
3119928	1	0.1%
2885869	1	0.1%
2783521	1	0.1%
2767969	1	0.1%
2605496	1	0.1%
2461048	1	0.1%

LA_Opioid_Prscrbng_Rate
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	749
Distinct (%)	60.0%
Missing	156
Missing (%)	11.1%
Infinite	0
Infinite (%)	0.0%
Mean	10.049792

Minimum	0
Maximum	97.47
Zeros	10
Zeros (%)	0.7%
Negative	0
Negative (%)	0.0%
Memory size	11.1 KiB

Quantile statistics

Minimum	0
5-th percentile	2.8075
Q1	5.5975
median	8.25
Q3	10.355
95-th percentile	19.661
Maximum	97.47
Range	97.47
Interquartile range (IQR)	4.7575

Descriptive statistics

Standard deviation	10.934707
Coefficient of variation (CV)	1.0880531
Kurtosis	30.185258
Mean	10.049792
Median Absolute Deviation (MAD)	2.395
Skewness	5.1095367
Sum	12542.14
Variance	119.56782
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	10	0.7%
7.88	7	0.5%
9.16	6	0.4%
7.93	6	0.4%
8	6	0.4%
11.59	5	0.4%
3.05	5	0.4%
6.06	5	0.4%
4.79	5	0.4%
7.16	5	0.4%
Other values (739)	1188	84.6%
(Missing)	156	11.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	10	0.7%
0.58	1	0.1%
1.15	1	0.1%
1.52	1	0.1%
1.55	1	0.1%
1.79	1	0.1%
1.82	1	0.1%
1.85	1	0.1%
1.91	1	0.1%
1.95	1	0.1%

Value	Count	Frequency (%)
97.47	1	0.1%
94.17	1	0.1%
91.93	1	0.1%
91.7	1	0.1%
91.31	1	0.1%
87.97	1	0.1%
87.93	1	0.1%
85.95	2	0.1%
85.81	1	0.1%
80.45	1	0.1%

LA_Opioid_Prscrbng_Rate_5Y_Chg
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	377
Distinct (%)	70.9%
Missing	872
Missing (%)	62.1%
Infinite	0
Infinite (%)	0.0%
Mean	3.0459398

Minimum	-14.26
Maximum	84.25
Zeros	1
Zeros (%)	0.1%
Negative	295
Negative (%)	21.0%
Memory size	11.1 KiB

Quantile statistics

Minimum	-14.26
5-th percentile	-4.4485
Q1	-1.5
median	-0.22
Q3	1.225
95-th percentile	38.52
Maximum	84.25
Range	98.51
Interquartile range (IQR)	2.725

Descriptive statistics

Standard deviation	14.251594
Coefficient of variation (CV)	4.6788822
Kurtosis	15.545047
Mean	3.0459398
Median Absolute Deviation (MAD)	1.365
Skewness	3.9421733
Sum	1620.44
Variance	203.10793
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-0.31	6	0.4%
1.03	5	0.4%
-0.36	5	0.4%
-0.17	5	0.4%
0.13	4	0.3%
-0.85	4	0.3%
-0.22	4	0.3%
-1.6	3	0.2%
-0.14	3	0.2%
-3.09	3	0.2%
Other values (367)	490	34.9%
(Missing)	872	62.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-14.26	1	0.1%
-12.55	1	0.1%
-10.85	1	0.1%
-10.61	1	0.1%
-9.74	1	0.1%
-9.62	1	0.1%
-8.38	1	0.1%
-8.01	1	0.1%
-7.97	1	0.1%
-7.79	1	0.1%

Value	Count	Frequency (%)
84.25	1	0.1%
81.97	1	0.1%
81.07	1	0.1%
78.69	1	0.1%
78.57	1	0.1%
75.64	1	0.1%
74.1	1	0.1%
72.93	1	0.1%
72.56	1	0.1%
62.57	1	0.1%

LA_Opioid_Prscrbng_Rate_1Y_Chg
Real number (ℝ)

Distinct	399
Distinct (%)	36.5%
Missing	311
Missing (%)	22.2%
Infinite	0
Infinite (%)	0.0%
Mean	0.55970723

Minimum	-12.33
Maximum	92.65
Zeros	10
Zeros (%)	0.7%
Negative	576
Negative (%)	41.0%
Memory size	11.1 KiB

Quantile statistics

Minimum	-12.33
5-th percentile	-1.93
Q1	-0.57
median	-0.06
Q3	0.46
95-th percentile	2.974
Maximum	92.65
Range	104.98
Interquartile range (IQR)	1.03

Descriptive statistics

Standard deviation	5.1390245
Coefficient of variation (CV)	9.1816297
Kurtosis	126.59373
Mean	0.55970723
Median Absolute Deviation (MAD)	0.52
Skewness	9.5944777
Sum	611.76
Variance	26.409573
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.18	12	0.9%
0.01	10	0.7%
-0.29	10	0.7%
-0.06	10	0.7%
0	10	0.7%
-0.12	9	0.6%
-0.4	9	0.6%
0.13	9	0.6%
-0.28	9	0.6%
-0.11	9	0.6%
Other values (389)	996	70.9%
(Missing)	311	22.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-12.33	1	0.1%
-12.31	1	0.1%
-8.01	1	0.1%
-7.96	1	0.1%
-6.59	1	0.1%
-5.86	1	0.1%
-5.78	1	0.1%
-5.74	1	0.1%
-5.64	1	0.1%
-5.14	1	0.1%

Value	Count	Frequency (%)
92.65	1	0.1%
50.32	1	0.1%
47.25	1	0.1%
45.81	1	0.1%
40.49	1	0.1%
40.35	1	0.1%
38.68	2	0.1%
24.63	1	0.1%
24.56	1	0.1%
23.6	1	0.1%

Auto

Heatmap
Table

	Year	Geo_Cd	Tot_Opioid_Clms	Tot_Clms	Opioid_Prscrbng_Rate	Opioid_Prscrbng_Rate_5Y_Chg	Opioid_Prscrbng_Rate_1Y_Chg	LA_Tot_Opioid_Clms	LA_Opioid_Prscrbng_Rate	LA_Opioid_Prscrbng_Rate_5Y_Chg	LA_Opioid_Prscrbng_Rate_1Y_Chg	Geo_Lvl	Geo_Desc	Plan_Type
Year	1.000	0.000	-0.134	0.024	-0.618	0.144	0.177	-0.123	-0.026	-0.111	-0.113	0.000	0.000	0.000
Geo_Cd	0.000	1.000	-0.033	-0.043	0.002	-0.052	-0.035	0.010	0.166	0.207	0.077	1.000	0.985	0.000
Tot_Opioid_Clms	-0.134	-0.033	1.000	0.956	0.306	0.013	-0.025	0.945	-0.136	0.135	0.109	0.959	0.297	0.077
Tot_Clms	0.024	-0.043	0.956	1.000	0.018	0.031	0.013	0.883	-0.187	0.067	0.062	0.997	0.322	0.122
Opioid_Prscrbng_Rate	-0.618	0.002	0.306	0.018	1.000	-0.150	-0.137	0.378	0.143	0.254	0.164	0.038	0.254	0.149
Opioid_Prscrbng_Rate_5Y_Chg	0.144	-0.052	0.013	0.031	-0.150	1.000	0.432	0.043	0.115	0.130	0.098	0.000	0.430	0.141
Opioid_Prscrbng_Rate_1Y_Chg	0.177	-0.035	-0.025	0.013	-0.137	0.432	1.000	0.000	0.065	0.086	-0.042	0.000	0.157	0.080
LA_Tot_Opioid_Clms	-0.123	0.010	0.945	0.883	0.378	0.043	0.000	1.000	0.176	0.335	0.210	0.923	0.260	0.091
LA_Opioid_Prscrbng_Rate	-0.026	0.166	-0.136	-0.187	0.143	0.115	0.065	0.176	1.000	0.578	0.277	0.046	0.406	0.096
LA_Opioid_Prscrbng_Rate_5Y_Chg	-0.111	0.207	0.135	0.067	0.254	0.130	0.086	0.335	0.578	1.000	0.486	0.328	0.447	0.059
LA_Opioid_Prscrbng_Rate_1Y_Chg	-0.113	0.077	0.109	0.062	0.164	0.098	-0.042	0.210	0.277	0.486	1.000	0.000	0.260	0.101
Geo_Lvl	0.000	1.000	0.959	0.997	0.038	0.000	0.000	0.923	0.046	0.328	0.000	1.000	0.982	0.000
Geo_Desc	0.000	0.985	0.297	0.322	0.254	0.430	0.157	0.260	0.406	0.447	0.260	0.982	1.000	0.000
Plan_Type	0.000	0.000	0.077	0.122	0.149	0.141	0.080	0.091	0.096	0.059	0.101	0.000	0.000	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	Year	Geo_Lvl	Geo_Cd	Geo_Desc	Plan_Type	Tot_Opioid_Clms	Tot_Clms	Opioid_Prscrbng_Rate	Opioid_Prscrbng_Rate_5Y_Chg	Opioid_Prscrbng_Rate_1Y_Chg	LA_Tot_Opioid_Clms	LA_Opioid_Prscrbng_Rate	LA_Opioid_Prscrbng_Rate_5Y_Chg	LA_Opioid_Prscrbng_Rate_1Y_Chg
0	2021	National	NaN	National	All	21654225.0	686625295.0	3.15	-2.23	-0.09	4672903.0	21.58	14.04	2.64
1	2021	National	NaN	National	FFS	5084859.0	180712324.0	2.81	-2.48	-0.15	736567.0	14.49	5.34	1.05
2	2021	National	NaN	National	MC	16569366.0	505912971.0	3.28	-2.14	-0.06	3936336.0	23.76	16.90	2.98
3	2021	State	1.0	Alabama	All	175237.0	7525456.0	2.33	-3.04	-0.38	7767.0	4.43	-0.36	-0.18
4	2021	State	1.0	Alabama	FFS	175237.0	7525456.0	2.33	-3.04	-0.38	7767.0	4.43	-0.36	-0.18
5	2021	State	1.0	Alabama	MC	0.0	0.0	NaN	NaN	NaN	0.0	NaN	NaN	NaN
6	2021	State	2.0	Alaska	All	58330.0	1436383.0	4.06	-3.84	-0.24	7076.0	12.13	0.54	-0.58
7	2021	State	2.0	Alaska	FFS	58330.0	1436383.0	4.06	-3.84	-0.24	7076.0	12.13	0.54	-0.58
8	2021	State	2.0	Alaska	MC	0.0	0.0	NaN	NaN	NaN	0.0	NaN	NaN	NaN
9	2021	State	4.0	Arizona	All	512306.0	14333371.0	3.57	-3.72	-0.10	32317.0	6.31	-4.52	-0.90

	Year	Geo_Lvl	Geo_Cd	Geo_Desc	Plan_Type	Tot_Opioid_Clms	Tot_Clms	Opioid_Prscrbng_Rate	Opioid_Prscrbng_Rate_5Y_Chg	Opioid_Prscrbng_Rate_1Y_Chg	LA_Tot_Opioid_Clms	LA_Opioid_Prscrbng_Rate	LA_Opioid_Prscrbng_Rate_5Y_Chg	LA_Opioid_Prscrbng_Rate_1Y_Chg
1394	2013	State	53.0	Washington	MC	431779.0	4637269.0	9.31	NaN	NaN	45745.0	10.59	NaN	NaN
1395	2013	State	54.0	West Virginia	All	401118.0	5794848.0	6.92	NaN	NaN	22227.0	5.54	NaN	NaN
1396	2013	State	54.0	West Virginia	FFS	329579.0	4721906.0	6.98	NaN	NaN	20429.0	6.20	NaN	NaN
1397	2013	State	54.0	West Virginia	MC	71539.0	1072942.0	6.67	NaN	NaN	1798.0	2.51	NaN	NaN
1398	2013	State	55.0	Wisconsin	All	899000.0	10155576.0	8.85	NaN	NaN	120342.0	13.39	NaN	NaN
1399	2013	State	55.0	Wisconsin	FFS	896650.0	10127535.0	8.85	NaN	NaN	119908.0	13.37	NaN	NaN
1400	2013	State	55.0	Wisconsin	MC	2350.0	28041.0	8.38	NaN	NaN	434.0	18.47	NaN	NaN
1401	2013	State	56.0	Wyoming	All	41202.0	529696.0	7.78	NaN	NaN	4230.0	10.27	NaN	NaN
1402	2013	State	56.0	Wyoming	FFS	41202.0	529696.0	7.78	NaN	NaN	4230.0	10.27	NaN	NaN
1403	2013	State	56.0	Wyoming	MC	0.0	0.0	NaN	NaN	NaN	0.0	NaN	NaN	NaN

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample